<%-- 
    Document   : update
    Created on : Jun 20, 2012, 7:01:32 AM
    Author     : karuna
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
   <%@page import="java.sql.*,java.io.*" %>
  <%
          Class.forName("oracle.jdbc.driver.OracleDriver");

         Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","pac","mca"); 

         Statement stmt=con.createStatement();
         String company_name=request.getParameter("company_name");
    String college_code=request.getParameter("college_code");
    String question=request.getParameter("question");
    
            PreparedStatement pstmt1=con.prepareStatement("insert into imp_cmp values(?,?,?)");
    
     pstmt1.setString(1,question);
     pstmt1.setString(2,college_code);
   pstmt1.setString(3,company_name);
      
     pstmt1.executeUpdate();
%>  
<html>
   <body><center> <table height="100%" width="50%" bgcolor="grey">
   <tr><td><font color="white">send sucessfully</td>
   <tr><td></td><tr><td></td></tr></tr></body></html>